﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CADISDataSetBoni" targetNamespace="http://tempuri.org/CADISDataSetBoni.xsd" xmlns:mstns="http://tempuri.org/CADISDataSetBoni.xsd" xmlns="http://tempuri.org/CADISDataSetBoni.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="CADISConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CADISConnectionString1 (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.JLD004_Interface_M3_Cadis.My.MySettings.GlobalReference.Default.CADISConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="F0012TableAdapter" GeneratorDataComponentClassName="F0012TableAdapter" Name="F0012" UserDataComponentName="F0012TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CADISConnectionString1 (MySettings)" DbObjectName="CADIS.dbo.F0012" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[F0012] WHERE (([ID] = @Original_ID) AND ((@IsNull_JLYEAR = 1 AND [JLYEAR] IS NULL) OR ([JLYEAR] = @Original_JLYEAR)) AND ((@IsNull_JLBUDGET = 1 AND [JLBUDGET] IS NULL) OR ([JLBUDGET] = @Original_JLBUDGET)) AND ((@IsNull_JLPCENT = 1 AND [JLPCENT] IS NULL) OR ([JLPCENT] = @Original_JLPCENT)) AND ((@IsNull_JLM01 = 1 AND [JLM01] IS NULL) OR ([JLM01] = @Original_JLM01)) AND ((@IsNull_JLM02 = 1 AND [JLM02] IS NULL) OR ([JLM02] = @Original_JLM02)) AND ((@IsNull_JLM03 = 1 AND [JLM03] IS NULL) OR ([JLM03] = @Original_JLM03)) AND ((@IsNull_JLM04 = 1 AND [JLM04] IS NULL) OR ([JLM04] = @Original_JLM04)) AND ((@IsNull_JLM05 = 1 AND [JLM05] IS NULL) OR ([JLM05] = @Original_JLM05)) AND ((@IsNull_JLM06 = 1 AND [JLM06] IS NULL) OR ([JLM06] = @Original_JLM06)) AND ((@IsNull_JLM07 = 1 AND [JLM07] IS NULL) OR ([JLM07] = @Original_JLM07)) AND ((@IsNull_JLM08 = 1 AND [JLM08] IS NULL) OR ([JLM08] = @Original_JLM08)) AND ((@IsNull_JLM09 = 1 AND [JLM09] IS NULL) OR ([JLM09] = @Original_JLM09)) AND ((@IsNull_JLM10 = 1 AND [JLM10] IS NULL) OR ([JLM10] = @Original_JLM10)) AND ((@IsNull_JLM11 = 1 AND [JLM11] IS NULL) OR ([JLM11] = @Original_JLM11)) AND ((@IsNull_JLM12 = 1 AND [JLM12] IS NULL) OR ([JLM12] = @Original_JLM12)) AND ((@IsNull_JLDESC1 = 1 AND [JLDESC1] IS NULL) OR ([JLDESC1] = @Original_JLDESC1)) AND ((@IsNull_JLDESC2 = 1 AND [JLDESC2] IS NULL) OR ([JLDESC2] = @Original_JLDESC2)) AND ((@IsNull_JLUSER = 1 AND [JLUSER] IS NULL) OR ([JLUSER] = @Original_JLUSER)) AND ((@IsNull_JLTDAY = 1 AND [JLTDAY] IS NULL) OR ([JLTDAY] = @Original_JLTDAY)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLYEAR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLYEAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLBUDGET" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLBUDGET" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLBUDGET" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLBUDGET" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLPCENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLPCENT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLPCENT" Precision="6" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="JLPCENT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM01" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM01" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM01" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM01" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM02" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM02" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM02" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM02" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM03" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM03" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM03" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM03" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM04" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM04" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM04" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM04" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM05" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM05" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM05" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM05" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM06" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM06" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM06" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM06" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM07" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM07" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM07" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM07" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM08" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM08" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM08" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM08" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM09" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM09" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM09" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM09" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM10" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM10" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM10" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM10" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM11" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM11" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM11" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM11" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM12" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM12" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM12" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM12" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDESC1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDESC1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDESC1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDESC1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDESC2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDESC2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDESC2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDESC2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLUSER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLUSER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLUSER" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLUSER" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTDAY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[F0012] ([JLYEAR], [JLBUDGET], [JLPCENT], [JLM01], [JLM02], [JLM03], [JLM04], [JLM05], [JLM06], [JLM07], [JLM08], [JLM09], [JLM10], [JLM11], [JLM12], [JLDESC1], [JLDESC2], [JLUSER], [JLTDAY]) VALUES (@JLYEAR, @JLBUDGET, @JLPCENT, @JLM01, @JLM02, @JLM03, @JLM04, @JLM05, @JLM06, @JLM07, @JLM08, @JLM09, @JLM10, @JLM11, @JLM12, @JLDESC1, @JLDESC2, @JLUSER, @JLTDAY);
SELECT ID, JLYEAR, JLBUDGET, JLPCENT, JLM01, JLM02, JLM03, JLM04, JLM05, JLM06, JLM07, JLM08, JLM09, JLM10, JLM11, JLM12, JLDESC1, JLDESC2, JLUSER, JLTDAY FROM F0012 WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLYEAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLBUDGET" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLBUDGET" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLPCENT" Precision="6" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="JLPCENT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM01" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM01" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM02" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM02" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM03" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM03" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM04" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM04" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM05" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM05" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM06" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM06" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM07" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM07" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM08" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM08" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM09" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM09" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM10" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM10" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM11" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM11" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM12" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM12" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDESC1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDESC1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDESC2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDESC2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLUSER" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLUSER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, JLYEAR, JLBUDGET, JLPCENT, JLM01, JLM02, JLM03, JLM04, JLM05, JLM06, JLM07, JLM08, JLM09, JLM10, JLM11, JLM12, JLDESC1, JLDESC2, JLUSER, JLTDAY FROM dbo.F0012</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[F0012] SET [JLYEAR] = @JLYEAR, [JLBUDGET] = @JLBUDGET, [JLPCENT] = @JLPCENT, [JLM01] = @JLM01, [JLM02] = @JLM02, [JLM03] = @JLM03, [JLM04] = @JLM04, [JLM05] = @JLM05, [JLM06] = @JLM06, [JLM07] = @JLM07, [JLM08] = @JLM08, [JLM09] = @JLM09, [JLM10] = @JLM10, [JLM11] = @JLM11, [JLM12] = @JLM12, [JLDESC1] = @JLDESC1, [JLDESC2] = @JLDESC2, [JLUSER] = @JLUSER, [JLTDAY] = @JLTDAY WHERE (([ID] = @Original_ID) AND ((@IsNull_JLYEAR = 1 AND [JLYEAR] IS NULL) OR ([JLYEAR] = @Original_JLYEAR)) AND ((@IsNull_JLBUDGET = 1 AND [JLBUDGET] IS NULL) OR ([JLBUDGET] = @Original_JLBUDGET)) AND ((@IsNull_JLPCENT = 1 AND [JLPCENT] IS NULL) OR ([JLPCENT] = @Original_JLPCENT)) AND ((@IsNull_JLM01 = 1 AND [JLM01] IS NULL) OR ([JLM01] = @Original_JLM01)) AND ((@IsNull_JLM02 = 1 AND [JLM02] IS NULL) OR ([JLM02] = @Original_JLM02)) AND ((@IsNull_JLM03 = 1 AND [JLM03] IS NULL) OR ([JLM03] = @Original_JLM03)) AND ((@IsNull_JLM04 = 1 AND [JLM04] IS NULL) OR ([JLM04] = @Original_JLM04)) AND ((@IsNull_JLM05 = 1 AND [JLM05] IS NULL) OR ([JLM05] = @Original_JLM05)) AND ((@IsNull_JLM06 = 1 AND [JLM06] IS NULL) OR ([JLM06] = @Original_JLM06)) AND ((@IsNull_JLM07 = 1 AND [JLM07] IS NULL) OR ([JLM07] = @Original_JLM07)) AND ((@IsNull_JLM08 = 1 AND [JLM08] IS NULL) OR ([JLM08] = @Original_JLM08)) AND ((@IsNull_JLM09 = 1 AND [JLM09] IS NULL) OR ([JLM09] = @Original_JLM09)) AND ((@IsNull_JLM10 = 1 AND [JLM10] IS NULL) OR ([JLM10] = @Original_JLM10)) AND ((@IsNull_JLM11 = 1 AND [JLM11] IS NULL) OR ([JLM11] = @Original_JLM11)) AND ((@IsNull_JLM12 = 1 AND [JLM12] IS NULL) OR ([JLM12] = @Original_JLM12)) AND ((@IsNull_JLDESC1 = 1 AND [JLDESC1] IS NULL) OR ([JLDESC1] = @Original_JLDESC1)) AND ((@IsNull_JLDESC2 = 1 AND [JLDESC2] IS NULL) OR ([JLDESC2] = @Original_JLDESC2)) AND ((@IsNull_JLUSER = 1 AND [JLUSER] IS NULL) OR ([JLUSER] = @Original_JLUSER)) AND ((@IsNull_JLTDAY = 1 AND [JLTDAY] IS NULL) OR ([JLTDAY] = @Original_JLTDAY)));
SELECT ID, JLYEAR, JLBUDGET, JLPCENT, JLM01, JLM02, JLM03, JLM04, JLM05, JLM06, JLM07, JLM08, JLM09, JLM10, JLM11, JLM12, JLDESC1, JLDESC2, JLUSER, JLTDAY FROM F0012 WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLYEAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLBUDGET" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLBUDGET" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLPCENT" Precision="6" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="JLPCENT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM01" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM01" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM02" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM02" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM03" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM03" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM04" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM04" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM05" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM05" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM06" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM06" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM07" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM07" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM08" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM08" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM09" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM09" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM10" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM10" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM11" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM11" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLM12" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM12" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDESC1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDESC1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDESC2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDESC2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLUSER" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLUSER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLYEAR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLYEAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLBUDGET" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLBUDGET" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLBUDGET" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLBUDGET" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLPCENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLPCENT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLPCENT" Precision="6" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="JLPCENT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM01" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM01" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM01" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM01" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM02" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM02" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM02" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM02" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM03" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM03" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM03" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM03" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM04" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM04" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM04" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM04" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM05" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM05" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM05" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM05" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM06" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM06" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM06" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM06" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM07" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM07" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM07" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM07" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM08" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM08" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM08" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM08" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM09" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM09" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM09" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM09" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM10" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM10" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM10" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM10" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM11" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM11" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM11" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM11" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLM12" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLM12" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLM12" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLM12" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDESC1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDESC1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDESC1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDESC1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDESC2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDESC2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDESC2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDESC2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLUSER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLUSER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLUSER" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLUSER" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTDAY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="CADIS.dbo.F0012" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="JLYEAR" DataSetColumn="JLYEAR" />
              <Mapping SourceColumn="JLBUDGET" DataSetColumn="JLBUDGET" />
              <Mapping SourceColumn="JLPCENT" DataSetColumn="JLPCENT" />
              <Mapping SourceColumn="JLM01" DataSetColumn="JLM01" />
              <Mapping SourceColumn="JLM02" DataSetColumn="JLM02" />
              <Mapping SourceColumn="JLM03" DataSetColumn="JLM03" />
              <Mapping SourceColumn="JLM04" DataSetColumn="JLM04" />
              <Mapping SourceColumn="JLM05" DataSetColumn="JLM05" />
              <Mapping SourceColumn="JLM06" DataSetColumn="JLM06" />
              <Mapping SourceColumn="JLM07" DataSetColumn="JLM07" />
              <Mapping SourceColumn="JLM08" DataSetColumn="JLM08" />
              <Mapping SourceColumn="JLM09" DataSetColumn="JLM09" />
              <Mapping SourceColumn="JLM10" DataSetColumn="JLM10" />
              <Mapping SourceColumn="JLM11" DataSetColumn="JLM11" />
              <Mapping SourceColumn="JLM12" DataSetColumn="JLM12" />
              <Mapping SourceColumn="JLDESC1" DataSetColumn="JLDESC1" />
              <Mapping SourceColumn="JLDESC2" DataSetColumn="JLDESC2" />
              <Mapping SourceColumn="JLUSER" DataSetColumn="JLUSER" />
              <Mapping SourceColumn="JLTDAY" DataSetColumn="JLTDAY" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="V1004TableAdapter" GeneratorDataComponentClassName="V1004TableAdapter" Name="V1004" UserDataComponentName="V1004TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CADISConnectionString1 (MySettings)" DbObjectName="CADIS.dbo.V1004" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT JLEMNM, JLYEAR, JLMOYR, JLCOUNT, GTotal, JLPARN, JLPARB, JLWORT, JLWORN, JLWORB, JLTRAT, JLTRAN, JLTRAB, JLEMNO, JLSRES, JLPARI, JLWORI, JLTRAI, GTotalI FROM dbo.V1004</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="JLEMNM" DataSetColumn="JLEMNM" />
              <Mapping SourceColumn="JLYEAR" DataSetColumn="JLYEAR" />
              <Mapping SourceColumn="JLMOYR" DataSetColumn="JLMOYR" />
              <Mapping SourceColumn="JLCOUNT" DataSetColumn="JLCOUNT" />
              <Mapping SourceColumn="GTotal" DataSetColumn="GTotal" />
              <Mapping SourceColumn="JLPARN" DataSetColumn="JLPARN" />
              <Mapping SourceColumn="JLPARB" DataSetColumn="JLPARB" />
              <Mapping SourceColumn="JLWORT" DataSetColumn="JLWORT" />
              <Mapping SourceColumn="JLWORN" DataSetColumn="JLWORN" />
              <Mapping SourceColumn="JLWORB" DataSetColumn="JLWORB" />
              <Mapping SourceColumn="JLTRAT" DataSetColumn="JLTRAT" />
              <Mapping SourceColumn="JLTRAN" DataSetColumn="JLTRAN" />
              <Mapping SourceColumn="JLTRAB" DataSetColumn="JLTRAB" />
              <Mapping SourceColumn="JLEMNO" DataSetColumn="JLEMNO" />
              <Mapping SourceColumn="JLSRES" DataSetColumn="JLSRES" />
              <Mapping SourceColumn="JLPARI" DataSetColumn="JLPARI" />
              <Mapping SourceColumn="JLWORI" DataSetColumn="JLWORI" />
              <Mapping SourceColumn="JLTRAI" DataSetColumn="JLTRAI" />
              <Mapping SourceColumn="GTotalI" DataSetColumn="GTotalI" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="F0013TableAdapter" GeneratorDataComponentClassName="F0013TableAdapter" Name="F0013" UserDataComponentName="F0013TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CADISConnectionString1 (MySettings)" DbObjectName="CADIS.dbo.F0013" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[F0013] WHERE (([ID] = @Original_ID) AND ((@IsNull_JLTECH = 1 AND [JLTECH] IS NULL) OR ([JLTECH] = @Original_JLTECH)) AND ((@IsNull_JLYEAR = 1 AND [JLYEAR] IS NULL) OR ([JLYEAR] = @Original_JLYEAR)) AND ((@IsNull_JLMONTH = 1 AND [JLMONTH] IS NULL) OR ([JLMONTH] = @Original_JLMONTH)) AND ((@IsNull_JLPRICE = 1 AND [JLPRICE] IS NULL) OR ([JLPRICE] = @Original_JLPRICE)) AND ((@IsNull_JLDESC = 1 AND [JLDESC] IS NULL) OR ([JLDESC] = @Original_JLDESC)) AND ((@IsNull_JLTDAY = 1 AND [JLTDAY] IS NULL) OR ([JLTDAY] = @Original_JLTDAY)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTECH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTECH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLTECH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTECH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLYEAR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLYEAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLMONTH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMONTH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLMONTH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLMONTH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLPRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLPRICE" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDESC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDESC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDESC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDESC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTDAY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[F0013] ([JLTECH], [JLYEAR], [JLMONTH], [JLPRICE], [JLDESC], [JLTDAY]) VALUES (@JLTECH, @JLYEAR, @JLMONTH, @JLPRICE, @JLDESC, @JLTDAY);
SELECT ID, JLTECH, JLYEAR, JLMONTH, JLPRICE, JLDESC, JLTDAY FROM F0013 WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLTECH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTECH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLYEAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLMONTH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLMONTH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLPRICE" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDESC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDESC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, JLTECH, JLYEAR, JLMONTH, JLPRICE, JLDESC, JLTDAY FROM dbo.F0013</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[F0013] SET [JLTECH] = @JLTECH, [JLYEAR] = @JLYEAR, [JLMONTH] = @JLMONTH, [JLPRICE] = @JLPRICE, [JLDESC] = @JLDESC, [JLTDAY] = @JLTDAY WHERE (([ID] = @Original_ID) AND ((@IsNull_JLTECH = 1 AND [JLTECH] IS NULL) OR ([JLTECH] = @Original_JLTECH)) AND ((@IsNull_JLYEAR = 1 AND [JLYEAR] IS NULL) OR ([JLYEAR] = @Original_JLYEAR)) AND ((@IsNull_JLMONTH = 1 AND [JLMONTH] IS NULL) OR ([JLMONTH] = @Original_JLMONTH)) AND ((@IsNull_JLPRICE = 1 AND [JLPRICE] IS NULL) OR ([JLPRICE] = @Original_JLPRICE)) AND ((@IsNull_JLDESC = 1 AND [JLDESC] IS NULL) OR ([JLDESC] = @Original_JLDESC)) AND ((@IsNull_JLTDAY = 1 AND [JLTDAY] IS NULL) OR ([JLTDAY] = @Original_JLTDAY)));
SELECT ID, JLTECH, JLYEAR, JLMONTH, JLPRICE, JLDESC, JLTDAY FROM F0013 WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLTECH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTECH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLYEAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLMONTH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLMONTH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLPRICE" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDESC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDESC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTECH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTECH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLTECH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTECH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLYEAR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLYEAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLMONTH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMONTH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLMONTH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLMONTH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLPRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLPRICE" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDESC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDESC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDESC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDESC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTDAY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="CADIS.dbo.F0013" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="JLTECH" DataSetColumn="JLTECH" />
              <Mapping SourceColumn="JLYEAR" DataSetColumn="JLYEAR" />
              <Mapping SourceColumn="JLMONTH" DataSetColumn="JLMONTH" />
              <Mapping SourceColumn="JLPRICE" DataSetColumn="JLPRICE" />
              <Mapping SourceColumn="JLDESC" DataSetColumn="JLDESC" />
              <Mapping SourceColumn="JLTDAY" DataSetColumn="JLTDAY" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="V1014TableAdapter" GeneratorDataComponentClassName="V1014TableAdapter" Name="V1014" UserDataComponentName="V1014TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CADISConnectionString1 (MySettings)" DbObjectName="CADIS.dbo.V1014" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT JLEMNM FROM dbo.V1014</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="JLEMNM" DataSetColumn="JLEMNM" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CADISDataSetBoni" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="CADISDataSetBoni" msprop:Generator_UserDSName="CADISDataSetBoni">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="F0012" msprop:Generator_TableClassName="F0012DataTable" msprop:Generator_TableVarName="tableF0012" msprop:Generator_TablePropName="F0012" msprop:Generator_RowDeletingName="F0012RowDeleting" msprop:Generator_UserTableName="F0012" msprop:Generator_RowChangingName="F0012RowChanging" msprop:Generator_RowEvHandlerName="F0012RowChangeEventHandler" msprop:Generator_RowDeletedName="F0012RowDeleted" msprop:Generator_RowEvArgName="F0012RowChangeEvent" msprop:Generator_RowChangedName="F0012RowChanged" msprop:Generator_RowClassName="F0012Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="JLYEAR" msprop:Generator_ColumnVarNameInTable="columnJLYEAR" msprop:Generator_ColumnPropNameInRow="JLYEAR" msprop:Generator_ColumnPropNameInTable="JLYEARColumn" msprop:Generator_UserColumnName="JLYEAR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLBUDGET" msprop:Generator_ColumnVarNameInTable="columnJLBUDGET" msprop:Generator_ColumnPropNameInRow="JLBUDGET" msprop:Generator_ColumnPropNameInTable="JLBUDGETColumn" msprop:Generator_UserColumnName="JLBUDGET" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLPCENT" msprop:Generator_ColumnVarNameInTable="columnJLPCENT" msprop:Generator_ColumnPropNameInRow="JLPCENT" msprop:Generator_ColumnPropNameInTable="JLPCENTColumn" msprop:Generator_UserColumnName="JLPCENT" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLM01" msprop:Generator_ColumnVarNameInTable="columnJLM01" msprop:Generator_ColumnPropNameInRow="JLM01" msprop:Generator_ColumnPropNameInTable="JLM01Column" msprop:Generator_UserColumnName="JLM01" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLM02" msprop:Generator_ColumnVarNameInTable="columnJLM02" msprop:Generator_ColumnPropNameInRow="JLM02" msprop:Generator_ColumnPropNameInTable="JLM02Column" msprop:Generator_UserColumnName="JLM02" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLM03" msprop:Generator_ColumnVarNameInTable="columnJLM03" msprop:Generator_ColumnPropNameInRow="JLM03" msprop:Generator_ColumnPropNameInTable="JLM03Column" msprop:Generator_UserColumnName="JLM03" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLM04" msprop:Generator_ColumnVarNameInTable="columnJLM04" msprop:Generator_ColumnPropNameInRow="JLM04" msprop:Generator_ColumnPropNameInTable="JLM04Column" msprop:Generator_UserColumnName="JLM04" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLM05" msprop:Generator_ColumnVarNameInTable="columnJLM05" msprop:Generator_ColumnPropNameInRow="JLM05" msprop:Generator_ColumnPropNameInTable="JLM05Column" msprop:Generator_UserColumnName="JLM05" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLM06" msprop:Generator_ColumnVarNameInTable="columnJLM06" msprop:Generator_ColumnPropNameInRow="JLM06" msprop:Generator_ColumnPropNameInTable="JLM06Column" msprop:Generator_UserColumnName="JLM06" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLM07" msprop:Generator_ColumnVarNameInTable="columnJLM07" msprop:Generator_ColumnPropNameInRow="JLM07" msprop:Generator_ColumnPropNameInTable="JLM07Column" msprop:Generator_UserColumnName="JLM07" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLM08" msprop:Generator_ColumnVarNameInTable="columnJLM08" msprop:Generator_ColumnPropNameInRow="JLM08" msprop:Generator_ColumnPropNameInTable="JLM08Column" msprop:Generator_UserColumnName="JLM08" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLM09" msprop:Generator_ColumnVarNameInTable="columnJLM09" msprop:Generator_ColumnPropNameInRow="JLM09" msprop:Generator_ColumnPropNameInTable="JLM09Column" msprop:Generator_UserColumnName="JLM09" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLM10" msprop:Generator_ColumnVarNameInTable="columnJLM10" msprop:Generator_ColumnPropNameInRow="JLM10" msprop:Generator_ColumnPropNameInTable="JLM10Column" msprop:Generator_UserColumnName="JLM10" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLM11" msprop:Generator_ColumnVarNameInTable="columnJLM11" msprop:Generator_ColumnPropNameInRow="JLM11" msprop:Generator_ColumnPropNameInTable="JLM11Column" msprop:Generator_UserColumnName="JLM11" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLM12" msprop:Generator_ColumnVarNameInTable="columnJLM12" msprop:Generator_ColumnPropNameInRow="JLM12" msprop:Generator_ColumnPropNameInTable="JLM12Column" msprop:Generator_UserColumnName="JLM12" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLDESC1" msprop:Generator_ColumnVarNameInTable="columnJLDESC1" msprop:Generator_ColumnPropNameInRow="JLDESC1" msprop:Generator_ColumnPropNameInTable="JLDESC1Column" msprop:Generator_UserColumnName="JLDESC1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="512" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLDESC2" msprop:Generator_ColumnVarNameInTable="columnJLDESC2" msprop:Generator_ColumnPropNameInRow="JLDESC2" msprop:Generator_ColumnPropNameInTable="JLDESC2Column" msprop:Generator_UserColumnName="JLDESC2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="512" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLUSER" msprop:Generator_ColumnVarNameInTable="columnJLUSER" msprop:Generator_ColumnPropNameInRow="JLUSER" msprop:Generator_ColumnPropNameInTable="JLUSERColumn" msprop:Generator_UserColumnName="JLUSER" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLTDAY" msprop:Generator_ColumnVarNameInTable="columnJLTDAY" msprop:Generator_ColumnPropNameInRow="JLTDAY" msprop:Generator_ColumnPropNameInTable="JLTDAYColumn" msprop:Generator_UserColumnName="JLTDAY" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="V1004" msprop:Generator_TableClassName="V1004DataTable" msprop:Generator_TableVarName="tableV1004" msprop:Generator_TablePropName="V1004" msprop:Generator_RowDeletingName="V1004RowDeleting" msprop:Generator_UserTableName="V1004" msprop:Generator_RowChangingName="V1004RowChanging" msprop:Generator_RowEvHandlerName="V1004RowChangeEventHandler" msprop:Generator_RowDeletedName="V1004RowDeleted" msprop:Generator_RowEvArgName="V1004RowChangeEvent" msprop:Generator_RowChangedName="V1004RowChanged" msprop:Generator_RowClassName="V1004Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="JLEMNM" msprop:Generator_ColumnVarNameInTable="columnJLEMNM" msprop:Generator_ColumnPropNameInRow="JLEMNM" msprop:Generator_ColumnPropNameInTable="JLEMNMColumn" msprop:Generator_UserColumnName="JLEMNM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLYEAR" msprop:Generator_ColumnVarNameInTable="columnJLYEAR" msprop:Generator_ColumnPropNameInRow="JLYEAR" msprop:Generator_ColumnPropNameInTable="JLYEARColumn" msprop:Generator_UserColumnName="JLYEAR" type="xs:int" minOccurs="0" />
              <xs:element name="JLMOYR" msprop:Generator_ColumnVarNameInTable="columnJLMOYR" msprop:Generator_ColumnPropNameInRow="JLMOYR" msprop:Generator_ColumnPropNameInTable="JLMOYRColumn" msprop:Generator_UserColumnName="JLMOYR" type="xs:int" minOccurs="0" />
              <xs:element name="JLCOUNT" msprop:Generator_ColumnVarNameInTable="columnJLCOUNT" msprop:Generator_ColumnPropNameInRow="JLCOUNT" msprop:Generator_ColumnPropNameInTable="JLCOUNTColumn" msprop:Generator_UserColumnName="JLCOUNT" type="xs:decimal" minOccurs="0" />
              <xs:element name="GTotal" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnGTotal" msprop:Generator_ColumnPropNameInRow="GTotal" msprop:Generator_ColumnPropNameInTable="GTotalColumn" msprop:Generator_UserColumnName="GTotal" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLPARN" msprop:Generator_ColumnVarNameInTable="columnJLPARN" msprop:Generator_ColumnPropNameInRow="JLPARN" msprop:Generator_ColumnPropNameInTable="JLPARNColumn" msprop:Generator_UserColumnName="JLPARN" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLPARB" msprop:Generator_ColumnVarNameInTable="columnJLPARB" msprop:Generator_ColumnPropNameInRow="JLPARB" msprop:Generator_ColumnPropNameInTable="JLPARBColumn" msprop:Generator_UserColumnName="JLPARB" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLWORT" msprop:Generator_ColumnVarNameInTable="columnJLWORT" msprop:Generator_ColumnPropNameInRow="JLWORT" msprop:Generator_ColumnPropNameInTable="JLWORTColumn" msprop:Generator_UserColumnName="JLWORT" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLWORN" msprop:Generator_ColumnVarNameInTable="columnJLWORN" msprop:Generator_ColumnPropNameInRow="JLWORN" msprop:Generator_ColumnPropNameInTable="JLWORNColumn" msprop:Generator_UserColumnName="JLWORN" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLWORB" msprop:Generator_ColumnVarNameInTable="columnJLWORB" msprop:Generator_ColumnPropNameInRow="JLWORB" msprop:Generator_ColumnPropNameInTable="JLWORBColumn" msprop:Generator_UserColumnName="JLWORB" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLTRAT" msprop:Generator_ColumnVarNameInTable="columnJLTRAT" msprop:Generator_ColumnPropNameInRow="JLTRAT" msprop:Generator_ColumnPropNameInTable="JLTRATColumn" msprop:Generator_UserColumnName="JLTRAT" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLTRAN" msprop:Generator_ColumnVarNameInTable="columnJLTRAN" msprop:Generator_ColumnPropNameInRow="JLTRAN" msprop:Generator_ColumnPropNameInTable="JLTRANColumn" msprop:Generator_UserColumnName="JLTRAN" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLTRAB" msprop:Generator_ColumnVarNameInTable="columnJLTRAB" msprop:Generator_ColumnPropNameInRow="JLTRAB" msprop:Generator_ColumnPropNameInTable="JLTRABColumn" msprop:Generator_UserColumnName="JLTRAB" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLEMNO" msprop:Generator_ColumnVarNameInTable="columnJLEMNO" msprop:Generator_ColumnPropNameInRow="JLEMNO" msprop:Generator_ColumnPropNameInTable="JLEMNOColumn" msprop:Generator_UserColumnName="JLEMNO" type="xs:int" minOccurs="0" />
              <xs:element name="JLSRES" msprop:Generator_ColumnVarNameInTable="columnJLSRES" msprop:Generator_ColumnPropNameInRow="JLSRES" msprop:Generator_ColumnPropNameInTable="JLSRESColumn" msprop:Generator_UserColumnName="JLSRES" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLPARI" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnJLPARI" msprop:Generator_ColumnPropNameInRow="JLPARI" msprop:Generator_ColumnPropNameInTable="JLPARIColumn" msprop:Generator_UserColumnName="JLPARI" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLWORI" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnJLWORI" msprop:Generator_ColumnPropNameInRow="JLWORI" msprop:Generator_ColumnPropNameInTable="JLWORIColumn" msprop:Generator_UserColumnName="JLWORI" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLTRAI" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnJLTRAI" msprop:Generator_ColumnPropNameInRow="JLTRAI" msprop:Generator_ColumnPropNameInTable="JLTRAIColumn" msprop:Generator_UserColumnName="JLTRAI" type="xs:decimal" minOccurs="0" />
              <xs:element name="GTotalI" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnGTotalI" msprop:Generator_ColumnPropNameInRow="GTotalI" msprop:Generator_ColumnPropNameInTable="GTotalIColumn" msprop:Generator_UserColumnName="GTotalI" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="F0013" msprop:Generator_TableClassName="F0013DataTable" msprop:Generator_TableVarName="tableF0013" msprop:Generator_TablePropName="F0013" msprop:Generator_RowDeletingName="F0013RowDeleting" msprop:Generator_UserTableName="F0013" msprop:Generator_RowChangingName="F0013RowChanging" msprop:Generator_RowEvHandlerName="F0013RowChangeEventHandler" msprop:Generator_RowDeletedName="F0013RowDeleted" msprop:Generator_RowEvArgName="F0013RowChangeEvent" msprop:Generator_RowChangedName="F0013RowChanged" msprop:Generator_RowClassName="F0013Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="JLTECH" msprop:Generator_ColumnVarNameInTable="columnJLTECH" msprop:Generator_ColumnPropNameInRow="JLTECH" msprop:Generator_ColumnPropNameInTable="JLTECHColumn" msprop:Generator_UserColumnName="JLTECH" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLYEAR" msprop:Generator_ColumnVarNameInTable="columnJLYEAR" msprop:Generator_ColumnPropNameInRow="JLYEAR" msprop:Generator_ColumnPropNameInTable="JLYEARColumn" msprop:Generator_UserColumnName="JLYEAR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLMONTH" msprop:Generator_ColumnVarNameInTable="columnJLMONTH" msprop:Generator_ColumnPropNameInRow="JLMONTH" msprop:Generator_ColumnPropNameInTable="JLMONTHColumn" msprop:Generator_UserColumnName="JLMONTH" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLPRICE" msprop:Generator_ColumnVarNameInTable="columnJLPRICE" msprop:Generator_ColumnPropNameInRow="JLPRICE" msprop:Generator_ColumnPropNameInTable="JLPRICEColumn" msprop:Generator_UserColumnName="JLPRICE" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLDESC" msprop:Generator_ColumnVarNameInTable="columnJLDESC" msprop:Generator_ColumnPropNameInRow="JLDESC" msprop:Generator_ColumnPropNameInTable="JLDESCColumn" msprop:Generator_UserColumnName="JLDESC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLTDAY" msprop:Generator_ColumnVarNameInTable="columnJLTDAY" msprop:Generator_ColumnPropNameInRow="JLTDAY" msprop:Generator_ColumnPropNameInTable="JLTDAYColumn" msprop:Generator_UserColumnName="JLTDAY" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="V1014" msprop:Generator_TableClassName="V1014DataTable" msprop:Generator_TableVarName="tableV1014" msprop:Generator_TablePropName="V1014" msprop:Generator_RowDeletingName="V1014RowDeleting" msprop:Generator_UserTableName="V1014" msprop:Generator_RowChangingName="V1014RowChanging" msprop:Generator_RowEvHandlerName="V1014RowChangeEventHandler" msprop:Generator_RowDeletedName="V1014RowDeleted" msprop:Generator_RowEvArgName="V1014RowChangeEvent" msprop:Generator_RowChangedName="V1014RowChanged" msprop:Generator_RowClassName="V1014Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="JLEMNM" msprop:Generator_ColumnVarNameInTable="columnJLEMNM" msprop:Generator_ColumnPropNameInRow="JLEMNM" msprop:Generator_ColumnPropNameInTable="JLEMNMColumn" msprop:Generator_UserColumnName="JLEMNM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:F0012" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="F0013_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:F0013" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>